Framework / Formulas / Functions / Bitwise Functions
In This Topic
    Bitwise Functions
    In This Topic

     

    Syntax Description Example
    BITAND(n1[, n2,... nN]) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in all numbers are 1. Otherwise, the bit is set to 0. BITAND(7,2)
    Returns: 2
    (7 = 0111, 2 = 0010)
    BITNOT(nNumber) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bit in number is 0. Otherwise, the bit is set to 0. BITNOT(1)
    Returns: 2 ^ 32 - 1
    BITOR(n1[, n2,... nN]) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in at least one numbers is 1. Otherwise, the bit is set to 0. BITOR(5,3)
    Returns: 7
    (5 = 0101, 3 = 0011, 7 = 0111)
    BITXOR(n1[, n2,... nN]) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in bn1 AND bn2 are different. Otherwise, the bit is set to 0. BITXOR(5,3)
    Returns: 6
    (5 = 0101, 3 = 0011, 6 = 0110)

    See Also